Kolumna SickLeaveID tabeli SickLeave

Definicja kolumny SickLeaveID tabeli SickLeave

Name

SickLeaveID

Code

SickLeaveID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli SickLeave

Definicja kolumny EventID tabeli SickLeave

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli SickLeave

Definicja kolumny EpisodeID tabeli SickLeave

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FormSeries tabeli SickLeave

Definicja kolumny FormSeries tabeli SickLeave

Name

FormSeries

Code

FormSeries

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna FormNo tabeli SickLeave

Definicja kolumny FormNo tabeli SickLeave

Name

FormNo

Code

FormNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Numer mieszkania
EN: Flat number
DE: Die Nummer der Wohnung


Kolumna DateValue tabeli SickLeave

Definicja kolumny DateValue tabeli SickLeave

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StartDT tabeli SickLeave

Definicja kolumny StartDT tabeli SickLeave

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli SickLeave

Definicja kolumny StopDT tabeli SickLeave

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna SentDT tabeli SickLeave

Definicja kolumny SentDT tabeli SickLeave

Name

SentDT

Code

SentDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ArchivedDT tabeli SickLeave

Definicja kolumny ArchivedDT tabeli SickLeave

Name

ArchivedDT

Code

ArchivedDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli SickLeave

Definicja kolumny Comments tabeli SickLeave

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ZusStatus tabeli SickLeave

Definicja kolumny ZusStatus tabeli SickLeave

Name

ZusStatus

Code

ZusStatus

Data Type

VARCHAR2(20)

Mandatory

No

Comment

status dokumentu z ZUS


Kolumna DocumentState tabeli SickLeave

Definicja kolumny DocumentState tabeli SickLeave

Name

DocumentState

Code

DocumentState

Data Type

VARCHAR2(1)

Mandatory

No

Comment

status dokumentu N-nowe, S-wyslany


Kolumna DocumentType tabeli SickLeave

Definicja kolumny DocumentType tabeli SickLeave

Name

DocumentType

Code

DocumentType

Data Type

VARCHAR2(2)

Mandatory

No

Comment

typ zwolnienia E-elektroniczne


Kolumna DocumentDate tabeli SickLeave

Definicja kolumny DocumentDate tabeli SickLeave

Name

DocumentDate

Code

DocumentDate

Data Type

DATE

Mandatory

No

Comment

data wystawienia zwolnienia


Kolumna DocumentElectroDate tabeli SickLeave

Definicja kolumny DocumentElectroDate tabeli SickLeave

Name

DocumentElectroDate

Code

DocumentElectroDate

Data Type

DATE

Mandatory

No

Comment

data elektronizacji zwolnienia


Kolumna InsuredId tabeli SickLeave

Definicja kolumny InsuredId tabeli SickLeave

Name

InsuredId

Code

InsuredId

Data Type

NUMBER(10)

Mandatory

No

Comment

id ubezpieczonego


Kolumna InsuredFirstName tabeli SickLeave

Definicja kolumny InsuredFirstName tabeli SickLeave

Name

InsuredFirstName

Code

InsuredFirstName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

ubezpieczony imie


Kolumna InsuredLastName tabeli SickLeave

Definicja kolumny InsuredLastName tabeli SickLeave

Name

InsuredLastName

Code

InsuredLastName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

ubezpieczony nazwisko


Kolumna InsuredInsurance tabeli SickLeave

Definicja kolumny InsuredInsurance tabeli SickLeave

Name

InsuredInsurance

Code

InsuredInsurance

Data Type

VARCHAR2(1)

Mandatory

No

Comment

instytucja ubezpieczajaca


Kolumna InsuredPassport tabeli SickLeave

Definicja kolumny InsuredPassport tabeli SickLeave

Name

InsuredPassport

Code

InsuredPassport

Data Type

VARCHAR2(20)

Mandatory

No

Comment

ubezpieczony nr paszportu


Kolumna InsuredAddressId tabeli SickLeave

Definicja kolumny InsuredAddressId tabeli SickLeave

Name

InsuredAddressId

Code

InsuredAddressId

Data Type

NUMBER(10)

Mandatory

No

Comment

id adresu ubezpieczonego


Kolumna PatientToRecommend tabeli SickLeave

Definicja kolumny PatientToRecommend tabeli SickLeave

Name

PatientToRecommend

Code

PatientToRecommend

Data Type

VARCHAR2(1)

Mandatory

No

Comment

kod zalecenia lekarza 1-chory powinien lezec, 2-chory moze chodzic


Kolumna FamilyRelationShip tabeli SickLeave

Definicja kolumny FamilyRelationShip tabeli SickLeave

Name

FamilyRelationShip

Code

FamilyRelationShip

Data Type

VARCHAR2(30)

Mandatory

No

Comment

kod pokrewienstwa ubezpieczonego do pacjenta


Kolumna HospitalFrom tabeli SickLeave

Definicja kolumny HospitalFrom tabeli SickLeave

Name

HospitalFrom

Code

HospitalFrom

Data Type

DATE

Mandatory

No

Comment

pobyt w szpitalu od


Kolumna HospitalTo tabeli SickLeave

Definicja kolumny HospitalTo tabeli SickLeave

Name

HospitalTo

Code

HospitalTo

Data Type

DATE

Mandatory

No

Comment

pobyt w szpitalu do


Kolumna Code4 tabeli SickLeave

Definicja kolumny Code4 tabeli SickLeave

Name

Code4

Code

Code4

Data Type

VARCHAR2(5)

Mandatory

No

Comment

kod A|B|C|D|E


Kolumna IcdId tabeli SickLeave

Definicja kolumny IcdId tabeli SickLeave

Name

IcdId

Code

IcdId

Data Type

NUMBER(10)

Mandatory

No

Comment

id kodu choroby icd10


Kolumna CodeIcd10 tabeli SickLeave

Definicja kolumny CodeIcd10 tabeli SickLeave

Name

CodeIcd10

Code

CodeIcd10

Data Type

VARCHAR2(10)

Mandatory

No

Comment

id kodu choroby icd10


Kolumna EmployerId tabeli SickLeave

Definicja kolumny EmployerId tabeli SickLeave

Name

EmployerId

Code

EmployerId

Data Type

NUMBER(10)

Mandatory

No

Comment

id pracodawcy


Kolumna EmployerAddressId tabeli SickLeave

Definicja kolumny EmployerAddressId tabeli SickLeave

Name

EmployerAddressId

Code

EmployerAddressId

Data Type

NUMBER(10)

Mandatory

No

Comment

id adresu pracodawcy


Kolumna LicenceNo tabeli SickLeave

Definicja kolumny LicenceNo tabeli SickLeave

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer prawa wyk. zawodu lekarza


Kolumna DoctorFirstName tabeli SickLeave

Definicja kolumny DoctorFirstName tabeli SickLeave

Name

DoctorFirstName

Code

DoctorFirstName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

imie lekarza


Kolumna DoctorLastName tabeli SickLeave

Definicja kolumny DoctorLastName tabeli SickLeave

Name

DoctorLastName

Code

DoctorLastName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

nazwisko lekarza


Kolumna OrgUnitAddressId tabeli SickLeave

Definicja kolumny OrgUnitAddressId tabeli SickLeave

Name

OrgUnitAddressId

Code

OrgUnitAddressId

Data Type

NUMBER(10)

Mandatory

No

Comment

id adresu szpitala


Kolumna SendInFotoEmployer tabeli SickLeave

Definicja kolumny SendInFotoEmployer tabeli SickLeave

Name

SendInFotoEmployer

Code

SendInFotoEmployer

Data Type

VARCHAR2(1)

Mandatory

No

Comment

czy wysylac info do pracodawcy


Kolumna StayInZOZ tabeli SickLeave

Definicja kolumny StayInZOZ tabeli SickLeave

Name

StayInZOZ

Code

StayInZOZ

Data Type

VARCHAR2(1)

Mandatory

No

Comment

pobyt w stacjonarnym ZOZ


Kolumna DocumentBackInfo tabeli SickLeave

Definicja kolumny DocumentBackInfo tabeli SickLeave

Name

DocumentBackInfo

Code

DocumentBackInfo

Data Type

VARCHAR2(160)

Mandatory

No

Comment

opis przyczyny wstecznego wystawienia


Kolumna documentcancelinfo tabeli SickLeave

Definicja kolumny documentcancelinfo tabeli SickLeave

Name

documentcancelinfo

Code

documentcancelinfo

Data Type

VARCHAR2(160)

Mandatory

No

Comment

opis przyczyny anulowania lub uniewaznienia


Kolumna Active tabeli SickLeave

Definicja kolumny Active tabeli SickLeave

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

czy aktywny/skasowany rekord


Kolumna DocumentMessage tabeli SickLeave

Definicja kolumny DocumentMessage tabeli SickLeave

Name

DocumentMessage

Code

DocumentMessage

Data Type

VARCHAR2(160)

Mandatory

No

Comment

Komunikat wyswietlony w szczególnych przypadkach


Kolumna IsExternal tabeli SickLeave

Definicja kolumny IsExternal tabeli SickLeave

Name

IsExternal

Code

IsExternal

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Zwolnienie zewnetrzne


Kolumna ExternalSickLeaveSource tabeli SickLeave

Definicja kolumny ExternalSickLeaveSource tabeli SickLeave

Name

ExternalSickLeaveSource

Code

ExternalSickLeaveSource

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Pochodzenie zwolnienia


Kolumna EmployerShortName tabeli SickLeave

Definicja kolumny EmployerShortName tabeli SickLeave

Name

EmployerShortName

Code

EmployerShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

skrócona nazwa firmy


Kolumna EmployerFullName tabeli SickLeave

Definicja kolumny EmployerFullName tabeli SickLeave

Name

EmployerFullName

Code

EmployerFullName

Data Type

VARCHAR2(250)

Mandatory

No

Comment

pelna nazwa firmy


Kolumna EmployerFirstName tabeli SickLeave

Definicja kolumny EmployerFirstName tabeli SickLeave

Name

EmployerFirstName

Code

EmployerFirstName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

imie


Kolumna EmployerLastName tabeli SickLeave

Definicja kolumny EmployerLastName tabeli SickLeave

Name

EmployerLastName

Code

EmployerLastName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

nazwisko


Kolumna EmployerFromZUS tabeli SickLeave

Definicja kolumny EmployerFromZUS tabeli SickLeave

Name

EmployerFromZUS

Code

EmployerFromZUS

Data Type

NUMBER(3)

Mandatory

No

Comment

pobrany z ZUS


Kolumna EmployerSecret tabeli SickLeave

Definicja kolumny EmployerSecret tabeli SickLeave

Name

EmployerSecret

Code

EmployerSecret

Data Type

NUMBER(3)

Mandatory

No

Comment

platnik wrazliwy


Kolumna EmployerIsPUE tabeli SickLeave

Definicja kolumny EmployerIsPUE tabeli SickLeave

Name

EmployerIsPUE

Code

EmployerIsPUE

Data Type

NUMBER(3)

Mandatory

No

Comment

czy platnik ma konto w ZUS


Kolumna EmployerTaxPayerId tabeli SickLeave

Definicja kolumny EmployerTaxPayerId tabeli SickLeave

Name

EmployerTaxPayerId

Code

EmployerTaxPayerId

Data Type

VARCHAR2(30)

Mandatory

No

Comment

nr platnika VAT


Kolumna EmployerIdentNo tabeli SickLeave

Definicja kolumny EmployerIdentNo tabeli SickLeave

Name

EmployerIdentNo

Code

EmployerIdentNo

Data Type

VARCHAR2(30)

Mandatory

No

Comment

nr identyfikacyjny (PESEL)


Kolumna EmployerIdentTypeId tabeli SickLeave

Definicja kolumny EmployerIdentTypeId tabeli SickLeave

Name

EmployerIdentTypeId

Code

EmployerIdentTypeId

Data Type

NUMBER(10)

Mandatory

No

Comment

typ numeru identyfikacyjnego 1-nip, 2-pesel, 3-paszport


Kolumna EmployerNationalIDNo tabeli SickLeave

Definicja kolumny EmployerNationalIDNo tabeli SickLeave

Name

EmployerNationalIDNo

Code

EmployerNationalIDNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Pesel


Lista kluczy tabeli SickLeave

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SickLeave

Definicja klucza Identifier_1 tabeli SickLeave

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment